microsoft excel q/a Practice Questions Answers Test with Solutions & More Shortcuts

Question : 26

You can use the format painter multiple times before you turn it off by

a) You can use the format painter button only one time when you click it

b) Double clicking the format painter button

c) Pressing the Ctrl key and clicking the format painter button

d) Pressing the Alt key and clicking the format painter button

e) None of these

Question : 27

In a worksheet you can select

a) The entire worksheet

b) Rows

c) Columns

d) All of the above

e) None of these

Question : 28

Which of the following is a correct order of precedence in a formula calculation?

a) Multiplication and division, exponential positive and negative value

b) Multiplication and division, positive and negative values, addition and subtraction

c) Addition and subtraction, positive and negative values, exponentiation

d) All of above

e) None of these

Question : 29

Which of the following option is not available in Paste Speciat dialog box?

a) Add

b) Subtract

c) Divide

d) SORT

e) None of these

Question : 30

When you enter Sunday and fill right, Excel fill in with Monday, Tuesday and so on. From where Excel knows what to fill in next?

a) Auto Complete

b) AutoFormat

c) Custom List

d) Calculation Automatic

e) None of these